package com.jc.ds.model;

import java.math.BigDecimal;
import java.util.Date;

/**
 * xorder
 * @author 
 */
public class Xorder extends BaseValueObject {
    /**
     * 主键，自增 ID订单号
     */
    private Long id;

    /**
     * 渠道订单号
     */
    private String channelOrderId;

    /**
     * 父订单id
     */
    private String pId;

    /**
     * 订单来源：H5 商城销售 3000 APP商城 3001 微信商城 3002 系统其他出入库订单3005
     */
    private String channelSource;

    /**
     * 订单类型：销售订单 2000 福利领用 2002报废出库 2003检测出库 2004样品费用化 2005促销品 2006内部销售 2010 补发订单 2013其他出入库订单2014
     */
    private String orderType;

    /**
     * 订单同步时间
     */
    private Date channelCreateTime;

    /**
     * 订单状态：新建 1000已受理 1001已派单 1002派单失败 1003已审核 1004 审核未通过 1005 拣货中 1006拣货失败 1007 拣货完成 1008 已打包 1009 已出库 1010 市场经理审核通过 1101 市场经理审核未通过 1102 客户经理审核通过 1103 客户经理审核未通过 1104 客服审核通过 1105 客服审核未通过 1106  物流经理审核通过 1107 物流经理审核未通过 1108 财务已审核通过 1109 财务已审核未通过 1110 取消 9999
     */
    private String orderStatus;

    /**
     * 会员号
     */
    private String shopMemberId;

    /**
     * 会员名
     */
    private String memberName;

    /**
     * 会员邮箱
     */
    private String email;

    /**
     * 发货仓库id
     */
    private String storeId;

    /**
     * 发货仓库名称
     */
    private String storeName;

    /**
     * 是否货到付款 'true' 是  'false' 否
     */
    private String isHdfk;

    /**
     * 优惠金额
     */
    private BigDecimal promotionAmount;

    /**
     * 快递金额
     */
    private BigDecimal freightAmount;

    /**
     * 订单总金额
     */
    private BigDecimal totalAmount;

    /**
     * 已支付总金额
     */
    private BigDecimal paidAmount;

    /**
     * 现金支付总金额
     */
    private BigDecimal cashPaidAmount;

    /**
     * 账户余额支付总金额 用于平台有预存款的情况
     */
    private BigDecimal balancePaidAmount;

    /**
     * 已退款总金额
     */
    private BigDecimal returnAmount;

    /**
     * 未支付 4000 已支付 4444
     */
    private String paidStatus;

    /**
     * 退款状态  已退款 5555 退款中 5000
     */
    private String refundStatus;

    /**
     * 退货状态  申请退货 6000 市场经理审核通过 6001 市场经理审核未通过 6002 客户经理审核通过 6003 客户经理审核未通过 6004 客服审核通过 6005 客服审核未通过 6006 物流经理审核通过 6007 物流经理审核未通过 6008 财务已审核通过 6009 财务已审核未通过 6010 市场经理审核通过 6011 已退货 6666
     */
    private String returnStatus;

    /**
     * 快递公司代码
     */
    private String expressId;

    /**
     * 快递公司名称
     */
    private String expressName;

    /**
     * 快递单号
     */
    private String expressNo;

    /**
     * 收货人姓名
     */
    private String consigneeName;

    /**
     * 收货人联系电话
     */
    private String consigneePhone;

    /**
     * 收货人联系手机
     */
    private String consigneeMobile;

    /**
     * 邮编
     */
    private String consigneeZip;

    /**
     * 收货省ID
     */
    private String consigneeProvince;

    /**
     * 收货省名称
     */
    private String consigneeProvinceName;

    /**
     * 收货市ID
     */
    private String consigneeCity;

    /**
     * 收货市名称
     */
    private String consigneeCityName;

    /**
     * 收货区ID
     */
    private String consigneeRegion;

    /**
     * 收货区名称
     */
    private String consigneeRegionName;

    /**
     * 学校id
     */
    private String consigneeSchool;

    /**
     * 学校名字
     */
    private String consigneeSchoolName;

    /**
     * 收货详细地址
     */
    private String consigneeAddress;

    /**
     * 是否需要发票
     */
    private String isInvoice;

    /**
     * 订单创建时间
     */
    private Date createTime;

    /**
     * 订单更新时间
     */
    private Date updateTime;

    /**
     * 修改人
     */
    private String editor;

    /**
     * 发货时间
     */
    private Date sendGoodsTime;

    /**
     * 退货时间
     */
    private Date returnGoodsTime;

    /**
     * 订单是否冻结
     */
    private String isFreeze;

    /**
     * 付款类型: 99BILL,快钱 ALIPAY 支付宝  BANKCARDPAY 银行卡支付 TENPAY 财付通 POCKET	口袋通 ADVANCE货到付款支付 WECHAT 微信
     */
    private String payType;

    /**
     *  备注 
     */
    private String memo;

    /**
     * 是否合单1合单，0 不合单
     */
    private Integer isMergeOrder;

    /**
     * 买家留言
     */
    private String buyerMessage;

    /**
     * 买家备注
     */
    private String buyerMemo;

    /**
     * 卖家备注
     */
    private String sellerMemo;

    /**
     *  是否删除 
     */
    private String isDelete;

    /**
     * 支付时间
     */
    private String payTime;

    /**
     * 同步状态 默认PENDING 未同步，COMPLETE 已同步
     */
    private String processStatus;

    /**
     * 供应商代码
     */
    private String supplierId;

    /**
     * 供应商名称
     */
    private String supplierName;

    /**
     * 购买人身份证号
     */
    private String consigneeCardCode;

    /**
     * 购买人身份证正反面照片，如果是正反面，用逗号分割
     */
    private String consigneeCardPic;

    /**
     * 是否是海外购订单
     */
    private String isOverseas;

    /**
     *  扩展字段 
     */
    private String extend1;

    /**
     *  扩展字段 
     */
    private String extend2;

    /**
     *  扩展字段 
     */
    private String extend3;

    /**
     *  扩展字段
     */
    private String extend4;

    /**
     *  扩展字段
     */
    private String extend5;

    private String orderStr = null;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getChannelOrderId() {
        return channelOrderId;
    }

    public void setChannelOrderId(String channelOrderId) {
        this.channelOrderId = channelOrderId;
    }

    public String getpId() {
        return pId;
    }

    public void setpId(String pId) {
        this.pId = pId;
    }

    public String getChannelSource() {
        return channelSource;
    }

    public void setChannelSource(String channelSource) {
        this.channelSource = channelSource;
    }

    public String getOrderType() {
        return orderType;
    }

    public void setOrderType(String orderType) {
        this.orderType = orderType;
    }

    public Date getChannelCreateTime() {
        return channelCreateTime;
    }

    public void setChannelCreateTime(Date channelCreateTime) {
        this.channelCreateTime = channelCreateTime;
    }

    public String getOrderStatus() {
        return orderStatus;
    }

    public void setOrderStatus(String orderStatus) {
        this.orderStatus = orderStatus;
    }

    public String getShopMemberId() {
        return shopMemberId;
    }

    public void setShopMemberId(String shopMemberId) {
        this.shopMemberId = shopMemberId;
    }

    public String getMemberName() {
        return memberName;
    }

    public void setMemberName(String memberName) {
        this.memberName = memberName;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getStoreId() {
        return storeId;
    }

    public void setStoreId(String storeId) {
        this.storeId = storeId;
    }

    public String getStoreName() {
        return storeName;
    }

    public void setStoreName(String storeName) {
        this.storeName = storeName;
    }

    public String getIsHdfk() {
        return isHdfk;
    }

    public void setIsHdfk(String isHdfk) {
        this.isHdfk = isHdfk;
    }

    public BigDecimal getPromotionAmount() {
        return promotionAmount;
    }

    public void setPromotionAmount(BigDecimal promotionAmount) {
        this.promotionAmount = promotionAmount;
    }

    public BigDecimal getFreightAmount() {
        return freightAmount;
    }

    public void setFreightAmount(BigDecimal freightAmount) {
        this.freightAmount = freightAmount;
    }

    public BigDecimal getTotalAmount() {
        return totalAmount;
    }

    public void setTotalAmount(BigDecimal totalAmount) {
        this.totalAmount = totalAmount;
    }

    public BigDecimal getPaidAmount() {
        return paidAmount;
    }

    public void setPaidAmount(BigDecimal paidAmount) {
        this.paidAmount = paidAmount;
    }

    public BigDecimal getCashPaidAmount() {
        return cashPaidAmount;
    }

    public void setCashPaidAmount(BigDecimal cashPaidAmount) {
        this.cashPaidAmount = cashPaidAmount;
    }

    public BigDecimal getBalancePaidAmount() {
        return balancePaidAmount;
    }

    public void setBalancePaidAmount(BigDecimal balancePaidAmount) {
        this.balancePaidAmount = balancePaidAmount;
    }

    public BigDecimal getReturnAmount() {
        return returnAmount;
    }

    public void setReturnAmount(BigDecimal returnAmount) {
        this.returnAmount = returnAmount;
    }

    public String getPaidStatus() {
        return paidStatus;
    }

    public void setPaidStatus(String paidStatus) {
        this.paidStatus = paidStatus;
    }

    public String getRefundStatus() {
        return refundStatus;
    }

    public void setRefundStatus(String refundStatus) {
        this.refundStatus = refundStatus;
    }

    public String getReturnStatus() {
        return returnStatus;
    }

    public void setReturnStatus(String returnStatus) {
        this.returnStatus = returnStatus;
    }

    public String getExpressId() {
        return expressId;
    }

    public void setExpressId(String expressId) {
        this.expressId = expressId;
    }

    public String getExpressName() {
        return expressName;
    }

    public void setExpressName(String expressName) {
        this.expressName = expressName;
    }

    public String getExpressNo() {
        return expressNo;
    }

    public void setExpressNo(String expressNo) {
        this.expressNo = expressNo;
    }

    public String getConsigneeName() {
        return consigneeName;
    }

    public void setConsigneeName(String consigneeName) {
        this.consigneeName = consigneeName;
    }

    public String getConsigneePhone() {
        return consigneePhone;
    }

    public void setConsigneePhone(String consigneePhone) {
        this.consigneePhone = consigneePhone;
    }

    public String getConsigneeMobile() {
        return consigneeMobile;
    }

    public void setConsigneeMobile(String consigneeMobile) {
        this.consigneeMobile = consigneeMobile;
    }

    public String getConsigneeZip() {
        return consigneeZip;
    }

    public void setConsigneeZip(String consigneeZip) {
        this.consigneeZip = consigneeZip;
    }

    public String getConsigneeProvince() {
        return consigneeProvince;
    }

    public void setConsigneeProvince(String consigneeProvince) {
        this.consigneeProvince = consigneeProvince;
    }

    public String getConsigneeProvinceName() {
        return consigneeProvinceName;
    }

    public void setConsigneeProvinceName(String consigneeProvinceName) {
        this.consigneeProvinceName = consigneeProvinceName;
    }

    public String getConsigneeCity() {
        return consigneeCity;
    }

    public void setConsigneeCity(String consigneeCity) {
        this.consigneeCity = consigneeCity;
    }

    public String getConsigneeCityName() {
        return consigneeCityName;
    }

    public void setConsigneeCityName(String consigneeCityName) {
        this.consigneeCityName = consigneeCityName;
    }

    public String getConsigneeRegion() {
        return consigneeRegion;
    }

    public void setConsigneeRegion(String consigneeRegion) {
        this.consigneeRegion = consigneeRegion;
    }

    public String getConsigneeRegionName() {
        return consigneeRegionName;
    }

    public void setConsigneeRegionName(String consigneeRegionName) {
        this.consigneeRegionName = consigneeRegionName;
    }

    public String getConsigneeSchool() {
        return consigneeSchool;
    }

    public void setConsigneeSchool(String consigneeSchool) {
        this.consigneeSchool = consigneeSchool;
    }

    public String getConsigneeSchoolName() {
        return consigneeSchoolName;
    }

    public void setConsigneeSchoolName(String consigneeSchoolName) {
        this.consigneeSchoolName = consigneeSchoolName;
    }

    public String getConsigneeAddress() {
        return consigneeAddress;
    }

    public void setConsigneeAddress(String consigneeAddress) {
        this.consigneeAddress = consigneeAddress;
    }

    public String getIsInvoice() {
        return isInvoice;
    }

    public void setIsInvoice(String isInvoice) {
        this.isInvoice = isInvoice;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }

    public String getEditor() {
        return editor;
    }

    public void setEditor(String editor) {
        this.editor = editor;
    }

    public Date getSendGoodsTime() {
        return sendGoodsTime;
    }

    public void setSendGoodsTime(Date sendGoodsTime) {
        this.sendGoodsTime = sendGoodsTime;
    }

    public Date getReturnGoodsTime() {
        return returnGoodsTime;
    }

    public void setReturnGoodsTime(Date returnGoodsTime) {
        this.returnGoodsTime = returnGoodsTime;
    }

    public String getIsFreeze() {
        return isFreeze;
    }

    public void setIsFreeze(String isFreeze) {
        this.isFreeze = isFreeze;
    }

    public String getPayType() {
        return payType;
    }

    public void setPayType(String payType) {
        this.payType = payType;
    }

    public String getMemo() {
        return memo;
    }

    public void setMemo(String memo) {
        this.memo = memo;
    }

    public Integer getIsMergeOrder() {
        return isMergeOrder;
    }

    public void setIsMergeOrder(Integer isMergeOrder) {
        this.isMergeOrder = isMergeOrder;
    }

    public String getBuyerMessage() {
        return buyerMessage;
    }

    public void setBuyerMessage(String buyerMessage) {
        this.buyerMessage = buyerMessage;
    }

    public String getBuyerMemo() {
        return buyerMemo;
    }

    public void setBuyerMemo(String buyerMemo) {
        this.buyerMemo = buyerMemo;
    }

    public String getSellerMemo() {
        return sellerMemo;
    }

    public void setSellerMemo(String sellerMemo) {
        this.sellerMemo = sellerMemo;
    }

    public String getIsDelete() {
        return isDelete;
    }

    public void setIsDelete(String isDelete) {
        this.isDelete = isDelete;
    }

    public String getPayTime() {
        return payTime;
    }

    public void setPayTime(String payTime) {
        this.payTime = payTime;
    }

    public String getProcessStatus() {
        return processStatus;
    }

    public void setProcessStatus(String processStatus) {
        this.processStatus = processStatus;
    }

    public String getSupplierId() {
        return supplierId;
    }

    public void setSupplierId(String supplierId) {
        this.supplierId = supplierId;
    }

    public String getSupplierName() {
        return supplierName;
    }

    public void setSupplierName(String supplierName) {
        this.supplierName = supplierName;
    }

    public String getConsigneeCardCode() {
        return consigneeCardCode;
    }

    public void setConsigneeCardCode(String consigneeCardCode) {
        this.consigneeCardCode = consigneeCardCode;
    }

    public String getConsigneeCardPic() {
        return consigneeCardPic;
    }

    public void setConsigneeCardPic(String consigneeCardPic) {
        this.consigneeCardPic = consigneeCardPic;
    }

    public String getIsOverseas() {
        return isOverseas;
    }

    public void setIsOverseas(String isOverseas) {
        this.isOverseas = isOverseas;
    }

    public String getExtend1() {
        return extend1;
    }

    public void setExtend1(String extend1) {
        this.extend1 = extend1;
    }

    public String getExtend2() {
        return extend2;
    }

    public void setExtend2(String extend2) {
        this.extend2 = extend2;
    }

    public String getExtend3() {
        return extend3;
    }

    public void setExtend3(String extend3) {
        this.extend3 = extend3;
    }

    public String getExtend4() {
        return extend4;
    }

    public void setExtend4(String extend4) {
        this.extend4 = extend4;
    }

    public String getExtend5() {
        return extend5;
    }

    public void setExtend5(String extend5) {
        this.extend5 = extend5;
    }

    public void orderById(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by id asc";
            }else{
                this.orderStr = this.orderStr + ",id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by id desc";
            }else{
                this.orderStr = this.orderStr + ",id desc";
            }
        }
    }

    public void orderByChannelOrderId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by channel_order_id asc";
            }else{
                this.orderStr = this.orderStr + ",channel_order_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by channel_order_id desc";
            }else{
                this.orderStr = this.orderStr + ",channel_order_id desc";
            }
        }
    }

    public void orderByPId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by p_id asc";
            }else{
                this.orderStr = this.orderStr + ",p_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by p_id desc";
            }else{
                this.orderStr = this.orderStr + ",p_id desc";
            }
        }
    }

    public void orderByChannelSource(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by channel_source asc";
            }else{
                this.orderStr = this.orderStr + ",channel_source asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by channel_source desc";
            }else{
                this.orderStr = this.orderStr + ",channel_source desc";
            }
        }
    }

    public void orderByOrderType(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by order_type asc";
            }else{
                this.orderStr = this.orderStr + ",order_type asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by order_type desc";
            }else{
                this.orderStr = this.orderStr + ",order_type desc";
            }
        }
    }

    public void orderByChannelCreateTime(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by channel_create_time asc";
            }else{
                this.orderStr = this.orderStr + ",channel_create_time asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by channel_create_time desc";
            }else{
                this.orderStr = this.orderStr + ",channel_create_time desc";
            }
        }
    }

    public void orderByOrderStatus(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by order_status asc";
            }else{
                this.orderStr = this.orderStr + ",order_status asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by order_status desc";
            }else{
                this.orderStr = this.orderStr + ",order_status desc";
            }
        }
    }

    public void orderByShopMemberId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by shop_member_id asc";
            }else{
                this.orderStr = this.orderStr + ",shop_member_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by shop_member_id desc";
            }else{
                this.orderStr = this.orderStr + ",shop_member_id desc";
            }
        }
    }

    public void orderByMemberName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by member_name asc";
            }else{
                this.orderStr = this.orderStr + ",member_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by member_name desc";
            }else{
                this.orderStr = this.orderStr + ",member_name desc";
            }
        }
    }

    public void orderByEmail(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by Email asc";
            }else{
                this.orderStr = this.orderStr + ",Email asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by Email desc";
            }else{
                this.orderStr = this.orderStr + ",Email desc";
            }
        }
    }

    public void orderByStoreId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by store_id asc";
            }else{
                this.orderStr = this.orderStr + ",store_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by store_id desc";
            }else{
                this.orderStr = this.orderStr + ",store_id desc";
            }
        }
    }

    public void orderByStoreName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by store_name asc";
            }else{
                this.orderStr = this.orderStr + ",store_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by store_name desc";
            }else{
                this.orderStr = this.orderStr + ",store_name desc";
            }
        }
    }

    public void orderByIsHdfk(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_hdfk asc";
            }else{
                this.orderStr = this.orderStr + ",is_hdfk asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_hdfk desc";
            }else{
                this.orderStr = this.orderStr + ",is_hdfk desc";
            }
        }
    }

    public void orderByPromotionAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by promotion_amount asc";
            }else{
                this.orderStr = this.orderStr + ",promotion_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by promotion_amount desc";
            }else{
                this.orderStr = this.orderStr + ",promotion_amount desc";
            }
        }
    }

    public void orderByFreightAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by freight_amount asc";
            }else{
                this.orderStr = this.orderStr + ",freight_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by freight_amount desc";
            }else{
                this.orderStr = this.orderStr + ",freight_amount desc";
            }
        }
    }

    public void orderByTotalAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by total_amount asc";
            }else{
                this.orderStr = this.orderStr + ",total_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by total_amount desc";
            }else{
                this.orderStr = this.orderStr + ",total_amount desc";
            }
        }
    }

    public void orderByPaidAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by paid_amount asc";
            }else{
                this.orderStr = this.orderStr + ",paid_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by paid_amount desc";
            }else{
                this.orderStr = this.orderStr + ",paid_amount desc";
            }
        }
    }

    public void orderByCashPaidAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by cash_paid_amount asc";
            }else{
                this.orderStr = this.orderStr + ",cash_paid_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by cash_paid_amount desc";
            }else{
                this.orderStr = this.orderStr + ",cash_paid_amount desc";
            }
        }
    }

    public void orderByBalancePaidAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by balance_paid_amount asc";
            }else{
                this.orderStr = this.orderStr + ",balance_paid_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by balance_paid_amount desc";
            }else{
                this.orderStr = this.orderStr + ",balance_paid_amount desc";
            }
        }
    }

    public void orderByReturnAmount(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by return_amount asc";
            }else{
                this.orderStr = this.orderStr + ",return_amount asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by return_amount desc";
            }else{
                this.orderStr = this.orderStr + ",return_amount desc";
            }
        }
    }

    public void orderByPaidStatus(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by paid_status asc";
            }else{
                this.orderStr = this.orderStr + ",paid_status asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by paid_status desc";
            }else{
                this.orderStr = this.orderStr + ",paid_status desc";
            }
        }
    }

    public void orderByRefundStatus(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by refund_status asc";
            }else{
                this.orderStr = this.orderStr + ",refund_status asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by refund_status desc";
            }else{
                this.orderStr = this.orderStr + ",refund_status desc";
            }
        }
    }

    public void orderByReturnStatus(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by return_status asc";
            }else{
                this.orderStr = this.orderStr + ",return_status asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by return_status desc";
            }else{
                this.orderStr = this.orderStr + ",return_status desc";
            }
        }
    }

    public void orderByExpressId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by express_id asc";
            }else{
                this.orderStr = this.orderStr + ",express_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by express_id desc";
            }else{
                this.orderStr = this.orderStr + ",express_id desc";
            }
        }
    }

    public void orderByExpressName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by express_name asc";
            }else{
                this.orderStr = this.orderStr + ",express_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by express_name desc";
            }else{
                this.orderStr = this.orderStr + ",express_name desc";
            }
        }
    }

    public void orderByExpressNo(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by express_no asc";
            }else{
                this.orderStr = this.orderStr + ",express_no asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by express_no desc";
            }else{
                this.orderStr = this.orderStr + ",express_no desc";
            }
        }
    }

    public void orderByConsigneeName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_name asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_name desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_name desc";
            }
        }
    }

    public void orderByConsigneePhone(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_phone asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_phone asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_phone desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_phone desc";
            }
        }
    }

    public void orderByConsigneeMobile(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_mobile asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_mobile asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_mobile desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_mobile desc";
            }
        }
    }

    public void orderByConsigneeZip(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_zip asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_zip asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_zip desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_zip desc";
            }
        }
    }

    public void orderByConsigneeProvince(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_province asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_province asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_province desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_province desc";
            }
        }
    }

    public void orderByConsigneeProvinceName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_province_name asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_province_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_province_name desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_province_name desc";
            }
        }
    }

    public void orderByConsigneeCity(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_city asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_city asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_city desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_city desc";
            }
        }
    }

    public void orderByConsigneeCityName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_city_name asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_city_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_city_name desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_city_name desc";
            }
        }
    }

    public void orderByConsigneeRegion(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_region asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_region asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_region desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_region desc";
            }
        }
    }

    public void orderByConsigneeRegionName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_region_name asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_region_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_region_name desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_region_name desc";
            }
        }
    }

    public void orderByConsigneeSchool(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_school asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_school asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_school desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_school desc";
            }
        }
    }

    public void orderByConsigneeSchoolName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_school_name asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_school_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_school_name desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_school_name desc";
            }
        }
    }

    public void orderByConsigneeAddress(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_address asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_address asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_address desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_address desc";
            }
        }
    }

    public void orderByIsInvoice(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_invoice asc";
            }else{
                this.orderStr = this.orderStr + ",is_invoice asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_invoice desc";
            }else{
                this.orderStr = this.orderStr + ",is_invoice desc";
            }
        }
    }

    public void orderByCreateTime(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by create_time asc";
            }else{
                this.orderStr = this.orderStr + ",create_time asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by create_time desc";
            }else{
                this.orderStr = this.orderStr + ",create_time desc";
            }
        }
    }

    public void orderByUpdateTime(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by update_time asc";
            }else{
                this.orderStr = this.orderStr + ",update_time asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by update_time desc";
            }else{
                this.orderStr = this.orderStr + ",update_time desc";
            }
        }
    }

    public void orderByEditor(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by editor asc";
            }else{
                this.orderStr = this.orderStr + ",editor asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by editor desc";
            }else{
                this.orderStr = this.orderStr + ",editor desc";
            }
        }
    }

    public void orderBySendGoodsTime(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by send_goods_time asc";
            }else{
                this.orderStr = this.orderStr + ",send_goods_time asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by send_goods_time desc";
            }else{
                this.orderStr = this.orderStr + ",send_goods_time desc";
            }
        }
    }

    public void orderByReturnGoodsTime(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by return_goods_time asc";
            }else{
                this.orderStr = this.orderStr + ",return_goods_time asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by return_goods_time desc";
            }else{
                this.orderStr = this.orderStr + ",return_goods_time desc";
            }
        }
    }

    public void orderByIsFreeze(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_freeze asc";
            }else{
                this.orderStr = this.orderStr + ",is_freeze asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_freeze desc";
            }else{
                this.orderStr = this.orderStr + ",is_freeze desc";
            }
        }
    }

    public void orderByPayType(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by pay_type asc";
            }else{
                this.orderStr = this.orderStr + ",pay_type asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by pay_type desc";
            }else{
                this.orderStr = this.orderStr + ",pay_type desc";
            }
        }
    }

    public void orderByMemo(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by memo asc";
            }else{
                this.orderStr = this.orderStr + ",memo asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by memo desc";
            }else{
                this.orderStr = this.orderStr + ",memo desc";
            }
        }
    }

    public void orderByIsMergeOrder(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_merge_order asc";
            }else{
                this.orderStr = this.orderStr + ",is_merge_order asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_merge_order desc";
            }else{
                this.orderStr = this.orderStr + ",is_merge_order desc";
            }
        }
    }

    public void orderByBuyerMessage(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by buyer_message asc";
            }else{
                this.orderStr = this.orderStr + ",buyer_message asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by buyer_message desc";
            }else{
                this.orderStr = this.orderStr + ",buyer_message desc";
            }
        }
    }

    public void orderByBuyerMemo(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by buyer_memo asc";
            }else{
                this.orderStr = this.orderStr + ",buyer_memo asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by buyer_memo desc";
            }else{
                this.orderStr = this.orderStr + ",buyer_memo desc";
            }
        }
    }

    public void orderBySellerMemo(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by seller_memo asc";
            }else{
                this.orderStr = this.orderStr + ",seller_memo asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by seller_memo desc";
            }else{
                this.orderStr = this.orderStr + ",seller_memo desc";
            }
        }
    }

    public void orderByIsDelete(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_delete asc";
            }else{
                this.orderStr = this.orderStr + ",is_delete asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_delete desc";
            }else{
                this.orderStr = this.orderStr + ",is_delete desc";
            }
        }
    }

    public void orderByPayTime(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by pay_time asc";
            }else{
                this.orderStr = this.orderStr + ",pay_time asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by pay_time desc";
            }else{
                this.orderStr = this.orderStr + ",pay_time desc";
            }
        }
    }

    public void orderByProcessStatus(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by process_status asc";
            }else{
                this.orderStr = this.orderStr + ",process_status asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by process_status desc";
            }else{
                this.orderStr = this.orderStr + ",process_status desc";
            }
        }
    }

    public void orderBySupplierId(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by supplier_id asc";
            }else{
                this.orderStr = this.orderStr + ",supplier_id asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by supplier_id desc";
            }else{
                this.orderStr = this.orderStr + ",supplier_id desc";
            }
        }
    }

    public void orderBySupplierName(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by supplier_name asc";
            }else{
                this.orderStr = this.orderStr + ",supplier_name asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by supplier_name desc";
            }else{
                this.orderStr = this.orderStr + ",supplier_name desc";
            }
        }
    }

    public void orderByConsigneeCardCode(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_card_code asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_card_code asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_card_code desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_card_code desc";
            }
        }
    }

    public void orderByConsigneeCardPic(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by consignee_card_pic asc";
            }else{
                this.orderStr = this.orderStr + ",consignee_card_pic asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by consignee_card_pic desc";
            }else{
                this.orderStr = this.orderStr + ",consignee_card_pic desc";
            }
        }
    }

    public void orderByIsOverseas(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by is_overseas asc";
            }else{
                this.orderStr = this.orderStr + ",is_overseas asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by is_overseas desc";
            }else{
                this.orderStr = this.orderStr + ",is_overseas desc";
            }
        }
    }

    public void orderByExtend1(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend1 asc";
            }else{
                this.orderStr = this.orderStr + ",extend1 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend1 desc";
            }else{
                this.orderStr = this.orderStr + ",extend1 desc";
            }
        }
    }

    public void orderByExtend2(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend2 asc";
            }else{
                this.orderStr = this.orderStr + ",extend2 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend2 desc";
            }else{
                this.orderStr = this.orderStr + ",extend2 desc";
            }
        }
    }

    public void orderByExtend3(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend3 asc";
            }else{
                this.orderStr = this.orderStr + ",extend3 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend3 desc";
            }else{
                this.orderStr = this.orderStr + ",extend3 desc";
            }
        }
    }

    public void orderByExtend4(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend4 asc";
            }else{
                this.orderStr = this.orderStr + ",extend4 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend4 desc";
            }else{
                this.orderStr = this.orderStr + ",extend4 desc";
            }
        }
    }

    public void orderByExtend5(boolean isAsc) {
        if(isAsc){
            if(this.orderStr == null){
                this.orderStr = "order by extend5 asc";
            }else{
                this.orderStr = this.orderStr + ",extend5 asc";
            }
        }else{
            if(this.orderStr == null){
                this.orderStr = "order by extend5 desc";
            }else{
                this.orderStr = this.orderStr + ",extend5 desc";
            }
        }
    }
}